Interview Questions

1. Which of the following is true?

Options:

a. Entity Framework is an ORM framework.

b. Entity Framework is an open source ORM framework.

c. Entity Framework is database mapping tool.

d. Entity Framework is object mapping tool.

Reveal Answer

2. A pattern of loading related data where a query for one type of entity also loads related entities as part of the query is called__________?

Options:

a. Lazy loading

b. Eager loading

c. Explicit loading

d. Quick Loading

Reveal Answer

3. Which of the following development approaches are supported in Entity Framework?

Options:

a. Code First

b. Database First

c. Model First

Reveal Answer

4. What window in Visual Studio display CSDL, MSL and SSDL of Entity Framework?

Options:

a. Model window

b. Model Browser

c. EDM Designer

d. Solution Explorer

Reveal Answer

5. Which of the following is TRUE?

Options:

a. DbContext cannot be used in Code First approach

b. ObjectContext is a wrapper around DBContext

c. DbContext is a wrapper around ObjectContext

d. DbContext is a sealed class which cannot be override

Reveal Answer

6. CSDL stands for__________?

Options:

a. Common Schema Definition Language

b. Conceptual Schema Definition Language

c. Conceptual Store Definition Language

d. Conceptual Storage Definition Language

Reveal Answer

7. Which of the following query syntax can be used to query EDM?

Options:

a. LINQ-to-Entity

b. Entity SQL

c. Native SQL

Reveal Answer

8. An XML-based language that describes the storage model of an Entity Framework application is called____________?

Options:

a. SSDL

b. CSDL

c. EDM

d. MSL

Reveal Answer

9. An XML-based language that describes the mapping between the conceptual model and storage model of an Entity Framework Application is called__________?

Options:

a. SSDL

b. CSDL

c. MSL

d. EDM

Reveal Answer

10. Which of the following is NOT TRUE about the Entity Framework?

Options:

a. It automatically generates the classes from the model and updates these classes dynamically when the model is changed.

b. It takes care of database connectivity.

c. It provides query syntax for querying the model

d. It does not provide any mechanism to track changes to the model’s objects.

Reveal Answer

11. How do you change the state of an entity using DBContext?

Options:

a. myDbcontext.Entry(studentEntity).state = System.Data.Entity.EntityState.Modified

b. myDbcontext.Add(studentEntity).state = System.Data.Entity.EntityState.Modified

c. myDbcontext.Set(studentEntity).state = System.Data.Entity.EntityState.Modified

d. myDbcontext.Entity (studentEntity).ChangeState (System.Data.Entity.EntityState.Modified)

Reveal Answer

12. Which of the following is responsible for change tracking management?

Options:

a. DBContextManager

b. ObjectContextManager

c. ObjectStateManager

d. EntityObjectManager

Reveal Answer

13. How to execute raw SQL query using DBContext?

Options:

a. dbcontext.Database.SqlQuery("Select * from Student where studentid=1")

b. dbcontext.Students.SqlQuery("Select * from Student where studentid=1")

c. dbcontext.Configuration.SqlQuery("Select * from Student where studentid=1")

d. dbcontext.SqlQuery("Select * from Student where studentid=1")

Reveal Answer

14. How to disable Lazy loading using DBContext?

Options:

a. myDBContext.Database.LazyLoadingEnabled = false;

b. myDBContext.Configuration.LazyLoadingEnabled = false;

c. myDBContext.LazyLoadingEnabled = false;

d. myDBContext.Students.LazyLoadingEnabled = false;

Reveal Answer

15. Which interface you have to implement to get the reference of ObjectContext from DBContext?

Options:

a. IObjectContextAdapter

b. IDBContextAdapter

c. IEntityObjectContext

d. IObjectContext

Reveal Answer

16. How to add Student entity using DBContext?

Options:

a. myDBContext.Students.Add(new Student(){ StudentName = "newStudent" });

b. myDBContext.Add(new Student(){ StudentName = "newStudent" });

c. myDBContext.Students(new Student(){ StudentName = "newStudent" });

d. myDBContext.Set(new Student(){ StudentName = "newStudent" });

Reveal Answer

Interview Questions and Answer

1. Which of the following is true?

2. A pattern of loading related data where a query for one type of entity also loads related entities as part of the query is called__________?

3. Which of the following development approaches are supported in Entity Framework?

4. What window in Visual Studio display CSDL, MSL and SSDL of Entity Framework?

5. Which of the following is TRUE?

6. CSDL stands for__________?

7. Which of the following query syntax can be used to query EDM?

8. An XML-based language that describes the storage model of an Entity Framework application is called____________?

9. An XML-based language that describes the mapping between the conceptual model and storage model of an Entity Framework Application is called__________?

10. Which of the following is NOT TRUE about the Entity Framework?

11. How do you change the state of an entity using DBContext?

12. Which of the following is responsible for change tracking management?

13. How to execute raw SQL query using DBContext?

14. How to disable Lazy loading using DBContext?

15. Which interface you have to implement to get the reference of ObjectContext from DBContext?

16. How to add Student entity using DBContext?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources